SELECT Id FROM new_searchtable
where (water_body like 'Goose Pond') and type ='T'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Currently there are no listings for Goose Pond NH Condos
Sorry No Results were found
change property type or
click back button to search again.
or Change Town
Goose Pond NH Condos $0 to $30000000